﻿CREATE TABLE [dbo].[tblMaint_DatabaseFiles]
(
	dbf_id					int							NOT NULL	IDENTITY(1, 1),
	dbf_database_name		sysname						NOT NULL,
	dbf_log_date			datetime					NOT NULL,
	dbf_name				sysname						NOT NULL,
	dbf_physical_name		nvarchar(260)				NOT NULL,
	dbf_type				tinyint						NOT NULL,
	dbf_sizeMB				decimal(18, 2)				NOT NULL,
	dbf_free_sizeMB			decimal(18, 2)				NOT NULL,
	dbf_max_sizeMB			decimal(18, 2)				NOT NULL,
	dbf_growthMB			decimal(18, 2)				NOT NULL,
	dbf_is_percent_growth	bit							NOT NULL,
	CONSTRAINT				PK_tblMaint_DatabaseFiles			PRIMARY KEY CLUSTERED (dbf_id ASC)
)
